package com.itheima.health.dao;

import com.itheima.health.pojo.CheckItem;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;

/**
 * @Author: XuZhen
 * @Date: 上午 9:52 2021/2/25 0025
 * @Parms
 * @ReturnType:
 * @Description:
 **/
public interface CheckItemMapper extends Mapper<CheckItem> {
    @Select("select t3.* from t_checkgroup t1 join t_checkgroup_checkitem t2 on t1.id = t2.checkgroup_id join t_checkitem t3 on t2.checkitem_id = t3.id where t1.id = #{checkgroupId}")
    List<CheckItem> findByCheckgroupId(@Param("checkgroupId") Integer id);

}
